Schema Design and Management

Choosing Optimal Data Types

Whole Numbers

Real Numbers

String Types

Date and Time Types

Bit-Packed Data Types

JSON Data

Choosing Identifiers

Special Types of Data

Schema Design Gotchas in MySQL

Too Many Columns

Too Many Joins

The All-Powerful ENUM

The ENUM in Disguise

NULL Not Invented Here

Schema Management

Schema Management as Part of the Data Store Platform

Summary